Round 1 - Technical

🔹 Some basics of window functions in SQL

🔹 Given a table with src and dest columns which contains values like (x,y) & (y,x), write a SQL query to keep only (x,y) values in the output

-------------

| src | dest|

|-----|-------|

| a | b  |

| b | a  |

| c | d  |

| d | e  |

| e | f  |

| f | g  |

| g | e  |

| e | g  |

-------------

🔹 Python coding question to find repeated characters in a given string

Round 2 - Technical

🔹 Discussion around my past experience and projects

🔹 Questions about cloud services which I used in my projects

Round 3 - Technical

🔹 SQL queries related to nested subqueries and joins

🔹 Apache Spark fundamentals

🔹 Technical questions about Columnar NoSQL database

🔹 DSA Question related to prime numbers in an array

Round 4 - Technical

🔹 Discussion around my past experience and projects

🔹 Data warehousing fundamentals like Star Schema, Snowflake Schema, Fact and Dimension tables, SCD Types

🔹 SQL questions related to Case-When along with Group By

Round 5 - Bar Raiser

🔹 Hypothetical situation based questions which were related to Amazon’s 14 leadership principles

🔹 Let says are 2-3 members in your team and they have different opinions about your architecture design then how will you convince them

🔹 Some behavioural and team fitment related questions

Round 6 - Hiring Manager

🔹 Discussion around my past experience, projects and kind of use cases which solved in the past

🔹 Questions related to AWS services

🔹 What are you looking for in your next job?

🔹 Why do you want to switch from your current company?